﻿CREATE TABLE [dbo].[ServiceHistory]
(
[OID] [bigint] NOT NULL IDENTITY(1, 1),
[Version] [timestamp] NOT NULL,
[PersonnelID] [bigint] NOT NULL,
[BranchOfServiceID] [bigint] NOT NULL,
[RankID] [bigint] NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NULL,
[UnitAssignment] [varchar] (200) NULL,
[TypeOfDischargeID] [bigint] NOT NULL,
[Active] [tinyint] NOT NULL,
[UpdatedDate] [datetime] NOT NULL,
[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]


